<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Chapter 30 MySQL Workbench</title>
<link rel="stylesheet" href="mvl.css" type="text/css" />
<meta name="generator" content="DocBook XSL Stylesheets + chunker.py v1.9.2" />
<link rel="start" href="index.html" title="{book-title}" />
<link rel="up" href="" title="" />
<link rel="prev" href="mysql-enterprise.html" title="Chapter 29 MySQL Enterprise Edition" />
<link rel="next" href="faqs.html" title="Appendix A MySQL 8.0 Frequently Asked Questions" />
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF">
<div class="navheader">
<table width="100%" summary="Navigation header">
<tr>
<th colspan="3" align="center">Chapter 30 MySQL Workbench</th>
</tr>
<tr>
<td width="20%" align="left"><a accesskey="p" href="mysql-enterprise.html">Prev</a> </td>
<th width="60%" align="center"></th>
<td width="20%" align="right"> <a accesskey="n" href="faqs.html">Next</a></td>
</tr>
</table>
<hr>
</div>
<div class="chapter">
<div class="titlepage">
<div>
<div>
<h1 class="title"><a name="workbench"></a>Chapter 30 MySQL Workbench</h1>

</div>

</div>

</div>
<p>
    MySQL Workbench provides a graphical tool for working with MySQL servers
    and databases. MySQL Workbench fully supports MySQL versions 5.1 and
    above.
  </p><p>
    The following discussion briefly describes MySQL Workbench capabilities.
    For more information, see the MySQL Workbench manual, available at
    <a class="ulink" href="http://dev.mysql.com/doc/workbench/en/" target="_top">http://dev.mysql.com/doc/workbench/en/</a>.
  </p><p>
    MySQL Workbench provides five main areas of functionality:
</p>
<div class="itemizedlist">
<ul class="itemizedlist" style="list-style-type: disc; "><li class="listitem"><p>
        <span class="bold"><strong>SQL Development</strong></span>: Enables you to
        create and manage connections to database servers. As well as
        enabling you to configure connection parameters, MySQL Workbench
        provides the capability to execute SQL queries on the database
        connections using the built-in SQL Editor. This functionality
        replaces that previously provided by the Query Browser
        standalone application.
      </p></li><li class="listitem"><p>
        <span class="bold"><strong>Data Modeling</strong></span>: Enables you to
        create models of your database schema graphically, reverse and
        forward engineer between a schema and a live database, and edit
        all aspects of your database using the comprehensive Table
        Editor. The Table Editor provides easy-to-use facilities for
        editing Tables, Columns, Indexes, Triggers, Partitioning,
        Options, Inserts and Privileges, Routines and Views.
      </p></li><li class="listitem"><p>
        <span class="bold"><strong>Server Administration</strong></span>: Enables
        you to create and administer server instances.
      </p></li><li class="listitem"><p>
        <span class="bold"><strong>Data Migration</strong></span>: Allows you to
        migrate from Microsoft SQL Server, Sybase ASE, SQLite, SQL
        Anywhere, PostreSQL, and other RDBMS tables, objects and data to
        MySQL. Migration also supports migrating from earlier versions
        of MySQL to the latest releases.
      </p></li><li class="listitem"><p>
        <span class="bold"><strong>MySQL Enterprise Support</strong></span>:
        Support for Enterprise products such as MySQL Enterprise Backup and MySQL Audit.
</p></li></ul>
</div>
<p>
    MySQL Workbench is available in two editions, the Community Edition and
    the Commercial Edition. The Community Edition is available free of
    charge. The Commercial Edition provides additional Enterprise
    features, such as database documentation generation, at low cost.
</p>
</div>
<div class="copyright-footer">

</div>
<div class="navfooter">
<hr>
<table width="100%" summary="Navigation footer">
<tr>
<td width="40%" align="left"><a accesskey="p" href="mysql-enterprise.html">Prev</a></td>
<td width="20%" align="center"><a accesskey="u" href="">Up</a></td>
<td width="40%" align="right"> <a accesskey="n" href="faqs.html">Next</a></td>
</tr>
<tr>
<td width="40%" align="left" valign="top">Chapter 29 MySQL Enterprise Edition</td>
<td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td>
<td width="40%" align="right" valign="top">Appendix A MySQL 8.0 Frequently Asked Questions</td>
</tr>
</table>
</div>
</body>
</html>
